SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044573 LIMIT 1 [ RunTime:0.000523s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044573 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332546,264171,994691,295528,463209,342515,338138,952643,212902,793333,864355,333477,354911,635982,829954,757666,226444,947489,304018,462613,80695,572119,43590,316467,186582,282722,842027,305082,31651,842234,654607,381342,653586,865981,323021,685351,695737,196614,144145,118655,848039,253906,448378,771361,341833,676552,158920,981501,508305,256443,1000625,138571,154132,772346,527854,784002,369564,118808,261070,539095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]