SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001972s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494181 LIMIT 1 [ RunTime:0.000657s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494181 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101368,650612,987068,614470,555878,493888,413820,384993,162059,831847,833954,741103,9873,286211,538713,421714,69350,1043775,985873,444004,1044600,547186,153339,683910,947377,892912,280079,303948,1002908,994001,506885,164275,324074,907583,329194,117228,229696,791360,107505,240101,569565,308262,646794,568104,651932,509173,112712,931697,29239,195033,1044018,953732,408013,58182,587272,118340,231645,633081,940839,752917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]