SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421691 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421691 [ RunTime:0.004543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453320,220510,705159,403421,864466,420109,635937,814310,40055,905413,219142,131470,511424,205010,587816,196770,821098,886015,295333,234175,444519,865824,1047889,785705,288594,223384,539580,359586,652203,303620,1015638,339831,586158,505563,389063,318036,663616,177000,98029,450722,423390,292333,538069,153015,789216,941624,56511,76555,950620,931585,863786,642448,964585,344059,556529,266,426467,26654,1027459,675085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]