SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801728 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801728 [ RunTime:0.002539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (232683,411950,465976,82012,354777,917286,630880,210486,543571,845832,978990,229712,1026362,973825,122007,529518,965131,95871,455205,1015343,267394,301481,263107,758974,173569,762689,635767,1044893,243596,108507,27293,11718,97038,784716,181390,573479,74381,8734,84537,532549,882519,460430,422167,362544,706027,951996,588687,661430,508460,1019160,117792,640847,176489,532408,706512,858517,267304,829927,61671,299215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]