SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101526 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101526 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (276977,507191,854059,637586,218756,1030857,395717,67863,803449,516157,119623,986056,607593,800922,249381,362062,33445,721052,243989,501227,253008,637685,791206,623345,307647,1034716,487178,425840,1035419,308801,144946,591985,369229,133380,817431,225437,546419,957791,811633,871901,182898,903712,719827,361093,866510,244303,259172,391591,998033,963176,622943,917623,781102,565043,949075,264930,386061,518575,437484,499843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]