SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489214 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489214 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178125,53369,199024,1043735,377758,727677,930886,940690,329723,665623,254204,341296,377183,744960,621052,1042384,1034230,79716,1037042,796344,584108,790628,912596,176073,500549,1037418,716291,323568,437818,176299,279096,204397,999192,693869,907077,249749,130158,387701,32342,758324,748560,1007624,624414,7319,267735,728593,879720,1000525,922390,435811,660966,627854,885521,395812,845719,822840,944273,391599,950412,454713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]