SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002702s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198038 LIMIT 1 [ RunTime:0.001750s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198038 [ RunTime:0.004527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (973763,103191,1044912,836135,523583,1002236,1016054,927411,310361,454031,181556,61577,212621,410201,249994,606047,790254,720452,518952,298759,781939,215287,532669,278140,409276,158891,894046,67337,534351,593485,988513,318476,930456,667927,837852,428508,662572,667176,683016,495065,977152,920419,918164,346078,383366,999942,704404,195547,493260,944753,698652,45136,864027,837897,31674,1025379,732724,346454,169360,209057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001145s ]