SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040718 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040718 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741678,461987,1044136,853687,431353,307468,459913,881852,704853,947288,716517,838185,774132,344919,628587,721777,60217,1041825,644676,911624,169734,775854,873901,415097,948123,143289,894541,950128,539575,379101,671003,287197,838588,578193,603995,708313,486069,457885,408641,233321,898774,83986,486310,86054,714154,143813,605248,1038527,303524,312742,798688,1012208,640132,855542,211739,243223,422676,814487,246729,287850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]