SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 256413 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 256413 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (966874,908517,1005061,542898,907684,327416,190183,89975,868573,245051,983100,727014,14003,359024,1028777,957005,230983,271746,800072,276014,394805,71017,720239,935591,485349,544122,10425,166057,212819,538252,500672,228228,7857,75959,43122,7467,16377,40292,142952,1044742,199160,504194,219697,278245,608541,340540,503351,198474,681212,840343,228120,117477,778196,243775,575132,506461,412686,608703,864168,95573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 256413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 256413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]