SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 244874 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 244874 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543691,17511,345861,867444,56188,295746,78256,992873,202340,770720,954651,134577,562950,626924,272435,595241,1027763,213547,614081,455461,1029968,413316,1043621,285992,98636,167511,279813,873298,271043,141850,396,766198,531521,728928,114369,330840,482535,737232,368817,59262,994220,793708,28472,612486,162941,972547,555458,951172,779476,531543,145960,239524,490101,480068,834749,131399,75715,609542,180397,669231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000889s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 244874 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 244874 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]