SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520943 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520943 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8232,81956,1033042,483657,65940,824939,551470,851927,270757,598347,1032375,565899,449800,60718,85062,67810,809152,329826,195856,753184,751074,505313,918033,315409,747911,1023754,962994,72973,179845,172298,252546,859196,405092,116500,561497,39751,78484,1009845,205181,57920,1041343,972143,111517,524020,650657,43395,1018420,900197,572267,48984,166557,773301,963513,732641,269066,1035096,312547,583216,522548,967644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]