SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044847 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044847 [ RunTime:0.002788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620371,183338,758403,438894,77359,816004,950599,216843,214172,902465,740536,684190,635439,233789,508075,918721,248903,845318,606613,529795,414167,75133,783500,335276,527251,195798,965153,721187,826158,767538,42474,491084,127868,987313,928667,357344,152618,684517,458526,345940,260515,26082,1048005,547741,545072,969539,22483,589563,894094,369970,496952,760323,461980,147027,461796,576411,233370,1020755,83655,843181) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002806s ]