SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 144058 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 144058 [ RunTime:0.001415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563720,607663,711998,106949,817912,338247,689958,261207,79926,662499,455517,880915,416850,956038,889661,440598,804442,745947,567885,106975,987000,772424,944393,859956,17059,911916,109110,461796,575636,740104,226390,351053,106301,762595,314817,768224,512459,498042,521515,81278,225899,101615,959982,50568,519484,157269,519913,3090,624266,16547,394587,371455,106379,631919,109416,223070,465910,384393,574739,483631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 144058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 144058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001698s ]