SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419243 LIMIT 1 [ RunTime:0.001018s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419243 [ RunTime:0.002022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033457,542777,588867,1008188,760342,211609,262920,272535,39819,510284,302559,1032385,17656,881723,966836,858062,895538,408900,21171,898900,400129,6762,223445,109785,595721,724974,935605,290391,433453,721701,367919,901899,111754,265292,969098,481522,363071,819613,517704,534857,262958,856688,448677,507988,1015457,53490,139475,889498,1026943,93850,840064,507948,255752,437970,600983,688451,166892,354483,170746,3524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003943s ]