SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002794s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408021 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408021 [ RunTime:0.005243s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151321,566964,251670,857262,221706,146852,769758,944160,697959,415294,60510,25157,274132,40881,296043,228519,186441,523431,740495,846601,199646,173900,534023,989340,602465,758820,570050,961043,116540,591201,818700,1033397,693381,301074,714117,545304,1045131,830832,27290,943322,144738,895248,253058,727911,113411,899094,356,1009669,240180,381448,394339,301598,567955,1009664,436255,356269,371470,844167,774827,326542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]