SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42678 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42678 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734469,639634,886377,482262,39439,314964,406487,214860,831696,721548,467257,792846,618234,989060,395554,149428,119676,581684,331182,981640,350435,708131,932760,740553,55993,475015,559737,764633,592276,235841,619990,665417,208755,426660,513761,782092,901811,400597,705030,802430,1012593,146404,510123,473617,816283,802973,334080,654698,683666,386613,741039,976039,120921,500962,493963,10790,553067,735188,901011,532325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]