SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382890 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382890 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522256,600976,866896,163130,687673,882716,625362,787517,449389,818752,958076,271615,778503,247258,410952,752244,382291,1033869,633873,279094,776936,783958,27929,298362,332432,934227,706154,135984,970431,854350,846804,301168,1873,361997,345207,365640,887259,310844,989745,156767,405702,71794,285467,337055,1029945,662414,978585,138596,389312,308846,682080,120432,1035112,11907,820185,718714,125656,443465,386194,579853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]