SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478748 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478748 [ RunTime:0.009356s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11823,733932,987734,623535,1045216,184961,916250,897157,365251,810584,728271,347299,762229,31732,968030,490697,644037,137718,502600,896289,1024104,1021133,78284,453772,90429,960770,903558,726199,129481,374278,968791,5863,142795,825424,205437,23573,129023,106608,772069,583174,334747,355427,751373,833164,558799,500279,986042,221141,849168,12360,593354,140370,921610,120361,717424,957527,640500,127064,493510,365641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007714s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001560s ]