SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437034 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437034 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (33350,434811,888730,273515,738472,478405,987243,260589,181489,408513,392568,749343,35460,708941,460478,524041,267857,851931,998599,70653,290534,1002603,497149,199160,478590,704915,527725,6848,962782,408957,1007323,822541,178566,872709,617508,579817,770188,347917,827565,593757,26028,1009145,98154,564512,994301,478548,804963,366241,807448,776395,1029948,303133,471859,133530,580206,645132,979916,692592,499512,296413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437034 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437034 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]