SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548928 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548928 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493891,942611,106708,919325,485117,798479,600520,203253,144582,802203,36923,27483,6654,649485,887552,186358,875614,603088,80,1037908,235176,537102,129206,771530,992567,947207,698453,890363,160579,258522,221858,690048,49606,173319,429531,904715,1007518,514473,283139,729562,829690,693022,298431,316128,596226,1003315,618371,368641,792947,161986,992828,206069,647130,240578,296444,371262,448897,126770,932367,626687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001883s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]