SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001989s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471401 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471401 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729241,1025932,121413,702005,151989,781457,984220,1007449,126778,833723,242132,57283,919950,357462,870456,484953,625292,851167,40901,326414,876443,34425,568976,144031,869061,522009,211364,363496,503362,562738,988805,716946,887818,872010,354979,340276,999693,692441,522359,52878,242255,820521,922960,21430,894171,919133,431545,195716,1031916,720213,428333,284279,231381,109201,946864,203508,9017,135973,933902,561405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]