SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681599 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681599 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675646,486605,96422,782094,612740,531916,911311,103669,445134,533178,894859,363746,1008102,220281,304748,985983,784758,711956,677040,999044,837459,648171,948673,114898,1029058,975106,461151,908135,427436,1018993,966315,513668,830194,942468,426081,95239,222124,17475,345921,446796,475240,809675,864345,267695,468233,472670,43595,588290,954434,412166,649320,90727,469882,421048,122681,440491,961875,690432,362940,307437) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]