SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104353 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104353 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889213,285033,412373,728119,163864,913912,680798,868068,688497,416304,739070,247912,284391,467017,447811,275545,260000,852450,706786,570947,555869,314498,726175,594742,469582,174303,654804,640279,903250,272961,101843,40484,587260,894003,789014,95133,79652,776175,553393,420538,73680,760185,102281,712391,276978,426609,12236,750515,266653,162573,442694,581795,537650,619130,9237,179516,568651,458322,725069,747553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104353 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104353 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000373s ]