SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 645751 LIMIT 1 [ RunTime:0.003274s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 645751 [ RunTime:0.005679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241206,840813,201411,186293,1042952,1012045,126768,444477,679625,739479,681847,129203,331165,669069,792480,165155,289992,913889,1024019,573087,949968,943876,718010,886243,555720,753082,293927,201832,741997,182675,328935,94134,248747,126680,836755,1039743,120487,841766,517907,1020115,879718,830940,438125,784060,723828,867835,705234,460418,6070,977056,448987,310057,591302,615,397216,756531,297735,186312,939628,648833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 645751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 645751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]