SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340289 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340289 [ RunTime:0.002583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (716083,799085,377025,746421,198817,896644,662577,1021877,269870,453580,839040,1048743,316628,136811,715587,580982,987993,927343,435901,1040405,529065,1040462,107982,181584,497139,360331,309718,710677,109281,847060,739927,482452,267447,514969,21394,802418,992042,118505,979890,759644,280653,237370,2559,921966,123499,133169,41657,487486,833865,823298,215608,116771,220894,482125,59057,185421,583656,974733,419792,1046523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]