SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407436 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407436 [ RunTime:0.002088s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265176,221613,898654,746297,476039,350454,894321,1002054,495680,646225,862305,427402,801725,438648,213762,885270,484958,903694,205568,737311,414636,427707,697304,567778,426311,347277,935561,1018579,120078,767660,774110,283232,916814,343047,98624,842283,652324,861867,775701,1035527,820511,773459,608990,123619,761083,56203,388671,413855,851818,396455,763872,368002,995545,838818,825426,369897,827164,813560,279277,824020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000667s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]