SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544293 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544293 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677942,767518,258142,339928,856248,174189,238353,283510,305862,216200,961825,1027077,914715,437281,473777,837171,101529,1047639,100002,994037,919311,697915,481346,8248,16406,825983,720738,102802,541255,141124,412089,490121,326748,571386,545612,1011883,937560,112162,597456,874160,328342,581784,416531,935960,590590,335712,358641,831131,432731,7901,134575,932512,729279,214818,895304,746590,319695,351079,552897,547288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000707s ]