SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421046 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421046 [ RunTime:0.003348s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620142,215497,190451,119606,531314,676207,331644,345187,418401,332597,1010047,303051,649059,627430,907778,583874,1024371,625437,313419,156174,595742,636999,53139,542911,747398,855013,951439,48244,730557,51257,471472,383834,904877,195903,26322,168584,12659,371297,919283,958080,687600,657315,645416,519985,270035,473168,636522,249229,79734,977645,140174,716784,120008,530069,231959,195826,192019,1042739,290963,889924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]