SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004561 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004561 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105829,285140,107085,411823,879764,828716,897855,677721,1003127,447353,195553,404870,174239,975630,293016,493837,791621,551522,230125,197169,564537,176462,177360,688981,805608,841262,978308,229743,673446,489130,29378,130965,827019,996291,141276,457238,869728,764831,318700,918981,359322,888632,519795,496429,666544,532518,436689,547385,1019233,432043,662875,203268,571436,52423,218759,434838,912497,856128,659305,521403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]