SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401836 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401836 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759339,69272,867728,1037912,521926,756613,267779,850047,575736,674756,855798,56186,577250,634037,548941,491355,78306,547481,902017,563422,662224,971060,1017456,159236,565873,184298,116731,983755,736588,818836,271024,550754,198286,751431,90330,487102,507813,21928,866985,951594,299028,372371,1043707,969850,235174,20380,821173,282279,355840,864826,250191,399937,232047,370488,256369,584332,913486,482412,492600,175626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004334s ]