SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566191 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566191 [ RunTime:0.003047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843260,388825,286947,65036,586200,561930,801871,934205,832929,445927,729481,891579,487900,793349,608435,571610,57909,708898,136241,278210,588103,509501,227770,870162,344415,644412,246197,35073,970249,783897,702723,362470,328649,723781,767221,457445,906914,881213,675641,495317,849980,504671,489539,915596,749492,629043,764359,540031,336921,1039004,1046511,890378,1038092,449696,674403,682954,377027,45517,345060,415328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]