SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 240217 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 240217 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510804,741847,281903,781819,482686,942792,192035,474138,154484,503835,363067,46071,462011,669536,421954,660750,64066,334592,278980,365317,295713,730881,212548,174071,316679,48490,191030,1010482,419093,1038820,501451,467156,137605,418768,1004764,85831,736825,252694,1152,855621,312808,967433,13777,940144,687440,553050,610382,507747,902564,579458,175169,720021,322939,247411,472867,172353,16279,844695,864215,941588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 240217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 240217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]