SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002807s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495403 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495403 [ RunTime:0.002946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116242,465390,809766,458335,425232,223139,139408,281555,1043875,208857,150331,965435,1020177,169991,720902,606713,740289,385003,619186,695845,714550,343231,270897,3211,379679,57894,28965,809996,168504,169367,115807,723504,190184,706693,264417,515096,171375,694058,827237,482293,245121,240275,222095,899807,762876,400864,638053,584183,251468,809666,767626,1038548,223127,282430,294142,863352,453611,862644,433276,815257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]