SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560540 LIMIT 1 [ RunTime:0.000819s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560540 [ RunTime:0.005773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (842386,334363,174806,943744,850746,627442,338839,789679,262231,374750,1041680,103656,135317,378835,918467,616788,139835,70257,162771,783906,41753,519107,730382,602644,947459,911482,221341,846871,730330,70691,657362,478492,956551,354935,288108,201766,969268,432615,643134,95929,435572,382201,531804,740837,22697,249431,271229,631756,547469,324447,449111,238102,799445,909437,600346,148385,287216,934214,480558,441663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002685s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001900s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002946s ]