SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041102 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041102 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (23874,683932,522336,357385,74070,305257,895654,562582,692453,118824,637573,218691,106661,330465,500238,115488,403672,24947,354190,976428,164773,1021948,377143,395666,887841,983087,123559,284470,643006,427251,913976,590297,830571,704732,275337,835704,543173,754677,57517,940472,838338,821404,736353,150604,717456,706104,288675,6122,541206,996146,407240,868776,535511,142369,131415,274112,205883,269861,879662,686804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]