SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420095 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420095 [ RunTime:0.002552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (667541,447516,641884,73681,742110,56411,650623,218173,514688,166173,579213,455556,849727,214437,996517,599001,645391,753132,599121,217166,922584,583360,443204,675723,91194,1022163,123238,712394,52539,907340,392346,393425,904452,908807,278503,112788,264281,660431,211461,864788,296860,919337,424558,638086,304454,778436,1045128,517794,906510,712847,250286,61142,538985,174311,1020409,842840,801774,892419,848972,689356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420095 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420095 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]