SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044291 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044291 [ RunTime:0.002499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192257,129530,127435,533008,167834,290165,461159,868587,961839,189915,972874,516976,948759,203748,189912,118123,877628,145922,536608,980516,19438,927811,474603,156584,840054,610768,427047,605682,154333,831018,614656,552406,872105,375684,565459,144921,315711,526882,550390,1028111,683621,860489,134256,24158,641331,259002,455191,479120,798487,414234,345320,829009,527673,676695,46618,1017116,1034136,630316,355273,381987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000957s ]