SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59691 LIMIT 1 [ RunTime:0.000610s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59691 [ RunTime:0.001998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380729,102515,562639,566355,961132,47053,932445,536278,333374,129846,557446,607918,496146,775419,390562,61153,210061,161930,723685,672629,923377,759103,191391,274573,941634,911510,267993,650144,286243,455232,163717,956584,291739,440625,148686,71337,571462,581155,606607,500207,331703,325393,165693,394340,68306,611446,6838,1000197,532655,247212,858533,46762,375809,626134,804222,473627,149236,391699,979537,116571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001215s ]