SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390910 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390910 [ RunTime:0.002259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413031,240727,132284,248827,847719,652007,734627,279857,365121,593995,955774,824286,577836,390518,969153,148643,1027507,585960,471829,542099,233632,900416,630137,739869,491635,454975,964440,1034602,1033068,537632,288068,142318,440251,797448,189605,39869,993233,133648,740214,248496,702251,896357,641348,313727,916626,889459,449367,608598,643467,955217,951897,907555,1025184,341334,684114,843892,172620,311158,862388,178941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]