SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451968 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451968 [ RunTime:0.004402s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (704853,262306,549467,252600,67852,75367,12145,148673,1004951,297780,179517,711657,187571,1008574,915424,815259,604341,576291,690308,997694,732740,878603,513178,502563,75006,677504,1025660,512811,1022190,159277,491746,570419,982480,441363,38148,230946,329320,45110,961300,553742,371072,585579,213898,408714,613170,215101,1028914,855544,54315,916187,696235,866711,970845,50268,592666,812937,45111,138335,116502,321910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]