SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043709 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043709 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229952,506532,684998,547755,188967,334775,148694,197816,728807,281195,338558,733583,912168,31178,614880,679386,604264,738697,501058,438049,415689,374580,72268,215042,850762,68929,912479,809990,867281,823038,209230,686508,749952,680537,523904,157619,909162,544527,513981,265881,888435,792170,404225,186906,997931,201784,109609,257962,979063,758698,162798,875394,670838,547010,306766,767374,413874,742571,973855,899289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043709 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043709 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]