SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44824 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44824 [ RunTime:0.001647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337591,143740,854822,608372,130148,956381,235992,643838,676773,992333,386564,800492,856948,495158,131347,497731,109095,211385,578777,950471,293820,120955,623366,1016429,98854,508780,521758,364518,1017532,846657,202150,459913,569098,440217,285995,80013,706970,363269,315962,484443,332241,888696,575348,844089,474984,203073,605558,151453,502953,171583,992971,106479,7905,583947,467335,977448,573712,791792,767333,427203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44824 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44824 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001238s ]