SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491801 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491801 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003328,116717,737624,337898,232974,756261,494114,241036,865185,126978,632510,914237,547585,313275,400220,740690,544137,534444,968515,753416,65436,916044,579423,651404,148237,92586,579181,283941,280656,535602,414230,1024079,457567,867522,865577,544787,644512,552975,472703,751429,352064,296174,320806,178356,976868,934588,153274,402187,585810,873065,999313,926397,110276,760625,224414,214049,286899,747373,775376,270915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]