SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043768 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043768 [ RunTime:0.002533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022675,751645,1034550,685358,936338,42828,56278,43636,333057,227767,428217,689974,58838,120208,429423,592224,942320,153173,426516,564909,937619,1020217,335046,422221,568818,462912,928882,58397,121727,43179,197059,462001,670160,546421,342073,612846,859953,547063,1022899,127060,568354,668229,252386,296232,663493,1018438,948054,448197,993904,786589,559442,425723,913225,719259,168154,850212,722287,139175,267926,1506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043768 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043768 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]