SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027947 LIMIT 1 [ RunTime:0.003358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027947 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958366,320644,499812,849503,503673,689426,443666,952066,279425,196621,51514,800687,813148,232223,655962,786156,405272,845933,100185,938717,768591,483530,145090,298376,964148,4324,976044,223666,907835,164896,821159,791013,907810,650621,501927,813587,645339,163524,607337,1022633,759534,484919,629203,728513,788550,326085,25944,819274,592346,399741,266436,580244,766278,87087,620580,569771,107578,182030,176465,585796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003390s ]