SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465072 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465072 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451487,974217,1016244,713829,193383,272723,612541,66788,100216,304027,37840,477551,730047,230393,911699,427234,472205,121860,178484,410857,80109,102708,407608,657063,319593,427809,944685,532218,470292,149837,424170,741968,490481,208947,637516,438348,493345,344003,877331,537828,679954,804987,565913,381251,161603,1018593,54161,596697,271872,340241,256696,250443,1019183,993733,483478,759602,927579,62207,479448,361069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001738s ]