SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401470 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401470 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15706,345945,1047087,446632,288445,914298,737011,367610,307035,705771,471014,753186,1000515,535950,72394,23870,856391,1035819,242933,192087,230375,320933,795611,57916,493912,819555,18297,303638,187136,307191,87197,597468,5732,840502,581087,304045,518398,3404,733202,1023276,429505,824515,1036953,135277,949300,918250,751560,719996,34520,845437,113861,646936,852278,996940,850818,1004800,299999,383273,907657,103382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]