SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017440 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017440 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (561781,447583,577948,998868,388096,596749,681208,535813,212767,512308,580216,84786,827353,504880,199273,635240,241731,871087,129343,978514,668983,639582,165891,895236,486675,69337,36911,597469,593965,1043873,136384,615593,598157,563871,930237,1003780,287646,1046799,414658,7474,1037699,1044403,478229,508744,163530,441109,289267,973021,262362,806120,1033343,258251,381982,100038,573731,79952,630685,727573,331050,485579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]