SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104251 LIMIT 1 [ RunTime:0.001016s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104251 [ RunTime:0.002362s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110905,889065,719182,982251,454069,666506,21140,584084,696245,342954,677816,488453,749283,510981,676032,640911,359603,689009,532695,815195,982479,422917,496142,826934,834816,726764,916630,324273,320970,855676,904036,663111,455295,927598,579047,1016224,844323,183247,782951,103139,704965,165561,515889,580008,191843,691450,653839,443459,708957,970491,776093,694853,11640,495806,918282,469862,740813,1009137,395035,224276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]