SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291079 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291079 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566961,79633,607767,924302,533848,721203,33475,17096,632822,147152,1038613,920494,353238,540003,125503,213564,142198,902648,467602,764852,819781,128448,551197,543276,658811,964079,876071,837011,887844,951419,790152,502982,18324,544284,88161,990536,120064,109482,869300,687695,332660,714848,160128,725412,443716,875030,231737,523410,377756,925025,528020,702976,967691,217994,499886,440912,404395,657427,315341,234615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291079 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291079 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]