SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001611s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024710 LIMIT 1 [ RunTime:0.005694s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024710 [ RunTime:0.003944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845635,652291,17034,268601,200396,439754,541584,261641,542419,817251,112504,1001176,566743,462705,312379,237998,182051,610698,263290,231914,346350,415138,268490,96684,401057,786520,775040,157944,194042,569332,73201,186512,1013156,391074,446078,1018028,393879,520753,972327,549022,150458,480783,188399,145633,411433,473296,734139,700325,193356,231966,408457,162939,523362,498441,262196,230496,1020636,321139,892196,1014409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003785s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]