SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261434 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261434 [ RunTime:0.002667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502756,560748,30621,221290,713205,989036,895481,93911,65925,121393,339248,703853,776909,623477,156422,816184,541188,541607,729543,194108,948798,1009259,270934,285086,31031,680385,864552,878888,692631,490206,437222,553552,237478,405619,28667,484152,319432,840028,490966,286615,887705,278017,485272,234466,252922,854622,9363,129786,391715,414472,889987,2574,140567,81466,888915,530282,289964,447598,760164,929618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261434 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261434 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001977s ]