SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475054 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475054 [ RunTime:0.002025s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66575,966953,43760,875489,168373,1827,771443,1010008,617825,527279,227253,604450,918478,625877,478009,426941,16377,237697,342879,231265,412152,620299,923535,308391,921337,755444,515161,235996,67124,848868,167172,425114,946372,232480,954678,556550,912248,609253,12709,826074,505774,194786,581606,82556,787790,367229,867076,285516,484856,101761,213480,195138,115773,673766,591020,741229,687789,1025840,546671,964066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000873s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000861s ]