SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003048s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 667015 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 667015 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530475,708718,708226,1026499,251720,171639,265212,157800,429384,263522,347373,993640,28042,891063,687048,818526,577513,68843,515244,199753,386214,546357,277996,531275,493194,934036,460852,745082,23018,50050,912659,1031687,678374,792536,487416,386770,663819,231266,511871,545009,956119,487238,791783,973754,830611,40422,997918,102380,518712,670599,903047,632217,135836,606541,441031,307358,650969,20515,194289,63326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 667015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 667015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]