SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44220 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44220 [ RunTime:0.004584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65332,73397,415161,636523,1025953,366182,733999,985190,858101,925312,374670,239909,905959,621245,367518,300320,386472,32770,118671,107330,518226,327527,431621,32521,772202,92580,848319,752586,200070,693295,227159,1000558,757125,74121,571877,574845,126503,252981,358504,569948,749543,62718,952070,270607,1024483,396846,1048647,767402,416512,831140,735385,1039003,751183,272325,782124,924392,885828,671614,647068,388934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002779s ]