SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 146906 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 146906 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509704,1011080,251503,134346,592632,331053,639371,1048661,225590,804057,569341,940090,60146,919906,96678,757915,66126,962909,3924,56454,63552,1013633,166285,778033,1031977,732369,711115,457227,44685,53075,256325,73310,765531,840955,583281,416335,338175,250945,877136,63589,185031,701908,661736,51857,588321,139602,997090,819212,660117,702101,842741,766177,581886,536577,654703,542953,530679,446051,89469,611194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 146906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 146906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]