SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 738913 LIMIT 1 [ RunTime:0.004454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 738913 [ RunTime:0.003869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307218,971599,752673,375114,886964,108298,73404,280104,234514,1019397,293950,966309,739502,752399,125402,335599,404413,823061,1017421,261451,1010626,686452,515218,625048,484445,344006,184248,312224,240346,1043306,848521,845023,710523,1043952,653711,212227,144639,239933,797595,1047301,64820,551253,581676,261218,170351,43413,948615,915419,308012,604070,327144,174104,10609,680981,148927,405025,183966,547940,792756,487820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 738913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 738913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]