SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512035 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512035 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379318,359868,611769,774953,884543,739651,456654,942390,566444,34473,243940,298055,659496,362786,816154,279080,1036027,810284,635024,1043130,31176,846391,618931,907049,937482,862563,767487,437283,91962,135698,983833,765760,512889,938,735878,339588,327277,795482,700675,567061,411025,1019721,387315,459581,1027776,1018559,48191,560307,767330,1004083,35136,725767,958513,845574,915687,771848,442056,591014,309694,608808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]