SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506495 LIMIT 1 [ RunTime:0.001925s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506495 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618199,323917,696151,787253,817296,621982,1041118,165136,331732,809051,815104,1037323,92543,285371,488101,359084,556221,939543,293098,518291,864617,351054,520545,927117,105425,31582,938382,505353,868846,863656,284630,385610,107905,841238,859139,215279,966077,109359,681876,425133,995176,862024,175280,57666,254588,130797,659677,966894,410629,251763,717535,403628,737289,893639,44975,688408,350336,210679,883163,1041557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506495 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506495 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]