SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801227 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801227 [ RunTime:0.003699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18669,49113,282926,375972,75443,602853,457376,327567,10422,467777,1048820,864554,133748,347087,639107,261736,530034,121006,176161,945390,943519,1002833,478526,499414,990351,47774,888639,37505,212098,608520,172869,383040,736558,917086,890720,467440,471342,253227,523969,952163,184594,817609,681310,434088,289380,646474,718297,805949,406453,719932,36266,297910,583191,194646,495618,822367,384052,429934,247039,386148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801227 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801227 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001414s ]