SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328105 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328105 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208317,1037793,564832,574300,564120,531224,188101,1007312,824975,100499,738604,1032292,937568,493047,442757,639715,101464,126453,249885,769925,327487,483123,889420,975843,1042695,493001,414736,699025,86137,43069,969263,200240,326965,937171,233995,1039218,462069,459484,204991,487116,118205,136425,534645,661410,730436,754840,875010,794736,933065,455576,279095,837400,70294,102972,158480,821041,911667,987680,925622,995135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002756s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001120s ]