SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.008401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461693 LIMIT 1 [ RunTime:0.002444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461693 [ RunTime:0.011232s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998376,867941,339360,117001,406817,691393,179094,452048,1009454,99103,217539,610302,719210,801067,19353,795352,79593,382436,319768,927499,617277,79481,28543,676955,137768,661320,871617,677202,687848,71389,675415,602291,1022530,236315,757695,888618,1031687,257914,830736,959618,45027,1010162,844460,839270,29531,211445,909514,109427,693950,180911,246415,530783,404660,374742,448466,62367,581785,770687,704907,995958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000887s ]