SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001535s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468841 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468841 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421764,949596,168981,858871,425437,773709,234692,578482,982985,832441,393871,856564,310658,74843,233388,733981,71752,479925,407700,931727,682766,896144,38308,686156,989042,873921,1042724,349061,295887,660193,900376,833827,714792,630355,250810,940314,110886,648657,950309,361422,857494,467548,649172,405168,379004,33049,1025372,24338,120436,227313,769511,747345,975743,976983,234362,489798,370263,497739,657068,1045663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003497s ]