SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565570 LIMIT 1 [ RunTime:0.001015s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565570 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338796,680369,719058,899001,360964,174154,727315,1021581,523342,213316,834426,959656,525791,402653,122391,771029,714022,379291,995327,367830,115652,301294,355950,166408,441427,847584,914019,602117,899460,467865,844832,730321,726838,641302,310928,149390,334966,254539,964444,982903,330337,912009,24057,210044,840596,669551,752461,242112,552545,187607,316507,169724,501984,573505,513602,726860,283681,923196,570868,591526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001709s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]