SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002468s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497439 LIMIT 1 [ RunTime:0.000904s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497439 [ RunTime:0.002336s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104175,1013579,650307,507702,385127,131343,294116,468304,581107,231916,508212,17151,751038,688735,70908,1037734,483360,799311,935165,716717,125809,710502,432727,412940,768230,398102,539488,823581,655526,443600,610060,878354,415767,617589,797838,223890,1039285,391559,690820,80742,855116,664668,559968,274289,461782,624549,727090,380010,981158,426236,677812,181525,747072,315398,168076,707627,131357,605171,516119,653729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002897s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000783s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003679s ]