SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5437 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5437 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502145,518673,216043,526456,756659,168247,682762,3061,572517,1015687,427666,329448,521333,187975,396605,760296,931058,243699,305297,571971,581745,728170,736580,870062,962543,583765,577438,854757,437575,470133,69009,101876,356217,372004,600570,979827,96631,564839,549502,537820,933863,882114,834188,946492,1012776,49273,202471,1034814,695089,339911,755985,98276,245459,378089,387191,132663,87106,402444,419802,426816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]