SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200929 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200929 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (963473,183853,928734,552059,1043477,1046747,1010293,223330,421202,321353,1024378,625041,731704,670487,873704,961206,224412,96093,35810,348904,362460,846867,514957,892127,667200,677965,507974,839510,796325,414989,750265,268514,707872,847303,91048,621091,105747,281552,398605,393373,191824,340892,1033974,723854,918252,930250,475321,577622,291039,316112,922253,748705,512350,802049,9168,1011513,64618,891406,418609,592067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200929 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200929 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]