SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001425 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001425 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141888,951872,945251,741671,168274,997621,249879,595907,366778,404541,1033040,433270,981001,913303,179127,1007875,310728,693091,1026378,380396,83798,805181,595323,475311,177725,696436,849991,472363,60991,1034709,219011,164224,832049,727587,252042,788723,471681,627079,651013,502205,755912,787665,329950,88274,269598,59048,345837,159224,798718,500034,403543,102556,135650,645403,90435,650388,193603,705558,350849,525755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]