SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502952 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502952 [ RunTime:0.002371s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (589355,912694,927216,810699,572913,131468,855905,151939,903515,416036,667899,520300,263950,943634,58096,564270,514590,415984,272468,906439,139350,998328,933557,375904,520756,122957,39791,285391,44551,960228,124354,852486,734471,92300,939091,771806,1044196,954188,843280,545672,549728,688111,523555,623724,805499,226801,802815,804908,687008,487789,54628,92429,577515,716574,714925,240497,606264,176689,231836,90914) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]