SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469894 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469894 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154464,412442,452451,819615,638236,83218,722374,914063,271307,89979,470277,959973,844174,555741,183748,97278,681880,832476,892277,901019,647026,1041265,881782,798934,703078,494112,490557,230494,389980,374790,372755,174144,534770,73134,618723,857292,633603,534376,642584,72134,447469,385445,155575,433216,121135,750961,314361,633618,403308,470227,435159,963107,876666,1039569,445510,650506,848148,301339,998151,889709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001876s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]