SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506255 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506255 [ RunTime:0.002378s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (386911,655603,97602,720302,126824,874017,177719,354693,275653,832377,701051,555973,817648,405239,1036702,268634,448681,881195,285105,306419,987346,372532,225754,158860,810471,899186,73893,502483,538378,114964,593523,24641,987152,504341,1046002,127342,573391,489408,38583,751872,50871,1046870,439423,136620,994412,5068,428375,792767,896852,661295,478366,547217,517452,1010509,118941,432094,124844,628216,934868,492743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506255 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506255 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]