SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039174 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039174 [ RunTime:0.005992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826216,59582,119599,778898,734127,391311,920345,278939,674968,626488,919116,570902,964741,791962,533330,436426,773171,2556,412903,461970,824411,1036355,795452,352962,1020672,552818,499857,518822,815048,214220,645333,605397,677879,1007055,699124,865289,710244,839330,204967,563681,53228,500414,742084,1029582,389539,872106,448625,100790,869150,578440,459124,337530,377509,1022121,171853,815065,258532,901650,242711,23481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039174 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039174 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]