SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043112 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043112 [ RunTime:0.002142s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466282,1030544,704524,812307,1035673,374501,189443,57090,700673,373922,955181,627210,270140,69686,376828,686355,70396,94545,551965,1038604,582028,689905,862289,924147,42540,570122,56699,116260,286673,440152,992924,157642,96667,297504,269713,384530,724838,325695,697266,999661,165462,451943,542548,672217,45428,655129,623438,929338,622419,574611,471377,994529,368594,374697,462134,762644,991439,997628,777984,271478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]