SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105946 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105946 [ RunTime:0.002030s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (865897,305275,920893,276914,766951,577658,475903,415107,544639,176164,604730,707591,952771,842613,870219,188941,773178,990664,563142,647542,254764,510794,635807,624607,174766,29902,730305,886774,767619,532805,692268,283894,399388,794112,686309,387210,378050,896384,845423,846112,653580,934064,1037078,378928,179813,998983,486116,992627,171034,1033044,503510,109954,781026,124686,272223,591493,831031,590211,646504,550535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]