SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201707 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201707 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986859,798856,787502,1012434,733952,164112,722887,791055,588864,551521,206317,235849,494755,1043064,757367,675238,753565,943814,219116,814790,614814,76430,516746,795356,1027727,794677,666931,523818,211737,379371,41667,198015,390954,222009,683716,305297,915678,843053,239840,521280,759596,79692,566481,879369,431613,933308,877588,474481,914021,926729,791403,701831,757022,177963,881637,1938,301702,52733,809650,48464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201707 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201707 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]