SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001556 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001556 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158017,612967,743313,40478,927856,358022,833407,1012823,969913,189039,508772,700052,656229,386665,103654,480810,150227,737653,725147,956793,31038,753026,45908,44317,340620,439272,17536,40399,738642,862629,1005364,682929,786345,698114,905149,1032816,1010024,484393,922450,819755,901032,573310,510859,728389,656486,1015090,562814,17506,358419,209157,532922,854577,140026,957212,1003618,867646,648324,1039278,852868,784941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001556 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001556 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]