SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198110 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198110 [ RunTime:0.005298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (976580,615188,710898,908591,783426,293363,849812,640332,511497,703001,261703,373441,880134,855672,457670,301820,910670,896301,775730,225241,44468,113993,45847,504912,436259,386807,584092,976118,537440,1045109,448832,209577,341960,1046975,118908,757684,179936,638043,716830,813802,788176,606993,471629,616332,871217,396470,827279,954449,198174,929486,465229,96602,376261,184614,16148,4442,16800,55280,587273,226124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]