SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018674 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018674 [ RunTime:0.003048s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181002,912642,1016953,134302,765388,177019,377333,896469,725361,690170,994803,1029849,1023182,727352,959900,825582,646478,195335,110134,202769,130474,556032,424797,608050,555453,302366,643359,628686,35460,99792,493668,388620,415405,979014,349286,1000174,171424,1046840,968067,228484,671822,212715,679008,100039,293254,42653,774918,871367,853428,709987,472184,395540,763923,508447,199624,188852,224260,991941,564774,342954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]