SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 166650 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 166650 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176413,110996,257284,1008580,33082,283201,681799,574016,1028255,187436,530215,900198,63518,890440,214544,1036241,120787,693915,764948,686182,813641,428954,66209,710276,115512,866639,146292,127791,59422,917008,76682,643853,1007334,652041,324964,501798,577268,55812,672766,839430,240906,99556,797518,165812,585200,387875,141918,1022975,643128,508711,776068,30678,262017,1031639,320750,840149,649563,656606,448254,843579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 166650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 166650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000849s ]