SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004686s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367920 LIMIT 1 [ RunTime:0.001667s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367920 [ RunTime:0.003786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615569,634417,7428,444028,106918,721711,630557,347731,939137,217111,301592,422593,37361,914979,219054,238003,53639,57153,520213,320884,947004,155586,691490,383669,494707,622806,244220,299956,310836,81135,536713,153552,425850,760884,88844,16948,994477,237805,441046,301464,286460,31827,346641,1028073,374814,892001,666325,177030,566983,650380,1024739,901741,420914,752122,327317,68439,338413,653885,1035222,822416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001007s ]